Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
FinancialLedgerID (FK)(PK) | The reference for the FinancialLedgeraAccount | ID_ACNT_LDG | Identity | integer | FinancialLedgerAccount(CO_LE_ACNT_FN) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
BeginningAmount | The opening balance for each account for a specific fiscal period on the STORE FINNCIAL LEDGER. | MO_BGN_FSC_PRD | Money | decimal(16,5) | |
CumulativeAmount | The cumulative monetary amount of each account for a specific fiscal period on the STORE FINNCIAL LEDGER. | MO_CM_FSC_PRD | Money | decimal(16,5) | |
StatusCode | A code to denote the status of the STORE FINANCIAL LEDGER for a specific fiscal period, ie open or closed. | SC_PRD | Code2Status | char(2) | |